SUPPORT / SAMPLES & SAS NOTES
Problem Note 59000: PARTY_TRANSACTIONS and ACCOUNT_TRANSACTIONS SAS® data set views in SAS® Anti-Money Laundering contain too few transaction dates
 |  |  |  |
When you run the transactions_prep.sas macro in SAS Anti-Money Laundering, the resulting PARTY_TRANSACTIONS and ACCOUNT_TRANSACTIONS SAS data set views do not contain all of the expected transaction dates. The macro incorrectly considers non-business days when calculating the date range for transaction data used in a scenario.
To work around the problem for account transactions, make the changes shown below to the transactions_prep.sas macro. You can make similar changes to the macro to correct the dates for party transactions.
- Incorrect code:
data _null_;
format currentday date9.;
do i = 0 to &numdays - 1;
currentday=input(put(&runasofdate,8.),yymmdd8.) - i;
call symput('daydate'||left(trim(put(i,best32.))),'mst_prep.account_trans'||
kcompress(put(currentday,yymmdd10.),'-'));
end;
run;
format currentday date9.;
do i = 0 to &numdays - 1;
currentday=input(put(&runasofdate,8.),yymmdd8.) - i;
call symput('daydate'||left(trim(put(i,best32.))),'mst_prep.account_trans'||
kcompress(put(currentday,yymmdd10.),'-'));
end;
run;
- Correct code:
data _null_;
currentday = input(put(&runasofdate,8.),yymmdd8.);
do i = 0 to &numdays - 1;
currentday_number = input(put(currentday,date_to_num.),8.);
if currentday_number eq -1 then do; /*non-business day*/
currentday_prev = currentday;
do until (currentday_number ne -1);
currentday_prev = currentday_prev - 1;
currentday_number = input(put(currentday_prev,date_to_num.),8.);
end;
end;
currentday = input(put(&runasofdate,8.),yymmdd8.);
do i = 0 to &numdays - 1;
currentday_number = input(put(currentday,date_to_num.),8.);
if currentday_number eq -1 then do; /*non-business day*/
currentday_prev = currentday;
do until (currentday_number ne -1);
currentday_prev = currentday_prev - 1;
currentday_number = input(put(currentday_prev,date_to_num.),8.);
end;
end;
current_business_day = input(put(currentday_number, num_to_date.),8.);
call symput('daydate'||left(trim(put(i,best32.))),'mst_prep.account_trans'||put(current_business_day,yymmddn8.));
currentday = current_business_day - 1;
end;
run;
call symput('daydate'||left(trim(put(i,best32.))),'mst_prep.account_trans'||put(current_business_day,yymmddn8.));
currentday = current_business_day - 1;
end;
run;
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Anti-Money Laundering | Microsoft Windows Server 2003 for x64 | 5.1 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2008 | 5.1 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2008 R2 | 5.1 | 6.1 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 5.1 | 6.1 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Microsoft Windows XP Professional | 5.1 | 9.3 TS1M1 | ||||
| Windows 7 Enterprise 32 bit | 5.1 | 9.3 TS1M1 | ||||
| Windows 7 Enterprise x64 | 5.1 | 6.1 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Windows 7 Home Premium 32 bit | 5.1 | 9.3 TS1M1 | ||||
| Windows 7 Home Premium x64 | 5.1 | 9.3 TS1M1 | ||||
| Windows 7 Professional 32 bit | 5.1 | 9.3 TS1M1 | ||||
| Windows 7 Professional x64 | 5.1 | 6.1 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Windows 7 Ultimate 32 bit | 5.1 | 9.3 TS1M1 | ||||
| Windows 7 Ultimate x64 | 5.1 | 9.3 TS1M1 | ||||
| Windows Vista | 5.1 | 9.3 TS1M1 | ||||
| Windows Vista for x64 | 5.1 | 9.3 TS1M1 | ||||
| 64-bit Enabled AIX | 5.1 | 6.1 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| 64-bit Enabled Solaris | 5.1 | 6.1 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| HP-UX IPF | 5.1 | 6.1 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Linux for x64 | 5.1 | 6.1 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Solaris for x64 | 5.1 | 6.1 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 5.1 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 9.3 TS1M1 | ||||
| Microsoft® Windows® for x64 | 5.1 | 6.1 | 9.3 TS1M1 | 9.4 TS1M0 | ||